Localizing the audit log database

By default, the FDA Module audit log contains vault event descriptions in English. These descriptions will appear in reports and other places where the data is shown. Each description can be localized in the audit log database manually using the database management system tools or it can be more conveniently localized using a separate description file.

To localize the audit log database:

1. Open the following description file on the Meridian Enterprise application server in Microsoft Excel:

C:\Program Files\BC-Meridian\Program\BC Audit\Audit Actions ENG.xlsx.

2. Edit the action descriptions in column B to meet your requirements and save your changes as a new comma-separated value (CSV) file.
3. Copy the CSV file to the audit log database host computer, whether SQL Server or Oracle.

To load the modified description file into a SQL Server audit log database:

1. On the SQL Server host computer, navigate to the folder where you copied the description file and run the Bulk Copy Program (BCP.exe) as in the following example:

Note    If the modified description file uses the comma character (,) to separate fields instead of the semi-colon character (;), replace the semi-colon in the following example with a comma.

BCP Actions in <DescriptionFile>.csv -c -t ; -T -S <ServerName> -d <DatabaseName>

The program replaces the existing descriptions in the audit log database with your localized descriptions.

To load the modified description file into an Oracle audit log database:

1. Copy the following files from the Meridian Enterprise application server to the folder where you copied the definition file on the Oracle host computer:

C:\Program Files\BC-Meridian\Program\BC Audit\Ora_Import_Actions.bat
C:\Program Files\BC-Meridian\Program\BC Audit\Ora_Import_Actions.ctl

2. On the Oracle host computer, run the following command line:

Ora_Import_Actions.bat <OracleUser>

The program replaces the existing descriptions in the audit log database with your localized descriptions.